Open topic with navigation

Configure databases for Nintex Workflow

This section provides instructions for Nintex Workflow database configuration.

Nintex Workflow requires a configuration database. While the configuration database can technically serve as the sole content database for Nintex Workflow, we recommend multiple content databases to ensure high availability. For more information, see Content databases and performance.

To set up configuration and content databases

1. Create a Nintex configuration database:

   1. On the Central Administration Home page, click Nintex Workflow Management.

   2. Click Database setup.

   3. In the Configuration Database section, click Create.

   4. On the Create configuration database page, enter the name of your database server and enter a database name.

      Note: The default value for Database Server is the default SharePoint database server.

   5. Click OK.

      A database connection string appears in the Configuration Database section.

2. Add content databases as needed to store workflow and task history (optional; see Content databases and performance):

   1. To redisplay the database setup page, on the Central Administration Home page, click Nintex Workflow Management and then click Database setup.

   2. For each content database to be added, do the following:

      1. In the Content Databases section, click Add content database.

      2. In the Add content database page, enter the name of your database server and a database name; leave all other settings as default.

      3. Click OK.

         A database connection string appears in the Configuration Database section.

   3. (Optional.) Update content database parameters using the NWAdmin operation UpdateContentDatabaseParameters.

3. Map Nintex content databases to SharePoint content databases:

   1. To redisplay the database setup page, on the Central Administration Home page, click Nintex Workflow Management and then click Database setup.

   2. Click Manage database mappings.

   3. For each SharePoint content database corresponding to a site collection that uses Nintex Workflow, select a Nintex Workflow content database under Map to Workflow Content Database.

      For more information about database mapping for Nintex Workflow, see the following Nintex Connect article: Database Design Guide: Nintex Workflow.

   4. Click OK.

4. Run the IISreset command to implement the changes:

   1. Start a command prompt as an administrator.

      For instructions, see the following TechNet article: http://technet.microsoft.com/en-us/library/cc947813(v=WS.10).aspx

   2. Enter the following command.

      IISreset

Open topic with navigation